Spreadsheet SetAlias
|
Menu location
|
-
|
Workbenches
|
Spreadsheet
|
Default shortcut
|
Ctrl+Shift+A
|
Introduced in version
|
0.17
|
See also
|
None
|
|
Descrição
The
Spreadsheet SetAlias tool opens a dialog to define an alias for a cell. A cell can be referenced by its address (capital column letter + row number, e.g. B4) or by its alias.
Uso
- Make sure there is an active spreadsheet.
- Select a cell.
- There are several ways to invoke the tool:
- Press the
Set Alias button.
- Use the keyboard shortcut: Ctrl+Shift+A.
- Enter an alias:
- Only alphanumeric characters and underscores (
A
to Z
, a
to z
, 0
to 9
and _
) are allowed.
- The first character must be a letter.
- Using 1 or 2 capital letters followed by 1 to 5 numbers, for example
AB123
, is not allowed as this is considered a cell address.
- Character sequences that are units are not allowed. For example
W
is an invalid alias as it is the unit for Watt. Since FreeCAD supports many units it is best to avoid short aliases. See Expressions.
- Using the mathematical constants
pi
and e
as aliases will lead to errors and should be avoided.
- Do not use spaces in aliases as they will also lead to errors.
Spreadsheet
- Creation: New Spreadsheet, Import Spreadsheet, Export Spreadsheet, Merge Cells, Split Cell, Set Alias
- Aligment: Align Left, Align Horizontal Center, Align Right, Align Top, Align Vertical Center, Align Bottom
- Style: Style Bold, Style Italic, Style Underline
User documentation
- Getting started
- Installation: Download, Windows, Linux, Mac, Additional components, Docker, AppImage, Ubuntu Snap
- Basics: About FreeCAD, Interface, Mouse navigation, Selection methods, Object name, Preferences, Workbenches, Document structure, Properties, Help FreeCAD, Donate
- Help: Tutorials, Video tutorials
- Workbenches: Std Base, Assembly, BIM, CAM, Draft, FEM, Inspection, Material, Mesh, OpenSCAD, Part, PartDesign, Points, Reverse Engineering, Robot, Sketcher, Spreadsheet, Surface, TechDraw, Test Framework